CREATE OR REPLACE PACKAGE pkg_variables
IS

   --USE AT YOUR OWN RISK 
	--THIS PACKAGE CAN BE POWERFUL BUT DEADLY 
	
	TYPE type_hash_date
	IS TABLE OF DATE
	INDEX BY VARCHAR2( 100 );
	
	TYPE type_hash_big_vc
	IS TABLE OF VARCHAR2( 4000 )
	INDEX BY VARCHAR2( 100 );
	
	TYPE type_hash_med_vc
	IS TABLE OF VARCHAR2( 1000 )
	INDEX BY VARCHAR2( 100 );
	
	TYPE type_hash_sm_vc
	IS TABLE OF VARCHAR2( 100 )
	INDEX BY VARCHAR2( 100 );
	
	TYPE type_hash_num
	IS TABLE OF NUMBER
	INDEX BY VARCHAR2( 100 );
	
	TYPE type_hash_bool
	IS TABLE OF BOOLEAN
	INDEX BY VARCHAR2( 100 );
	
	hash_date type_hash_date;
	hash_big_vc type_hash_big_vc;
	hash_med_vc type_hash_med_vc;
	hash_sm_vc type_hash_sm_vc;
	hash_num type_hash_num;
	hash_bool type_hash_bool; 
	
	PROCEDURE clear_all;
	
END pkg_variables;
